UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xOtcNG5wtCrTg5Ym7LVzjxaIz0aMg612PxsrrfuUXvE='
WHERE
key_id = 'ce597275e4d972bdf92efa1218c104de731975b4673962db8be829a237c07631'
AND (
token = 'xOtcNG5wtCrTg5Ym7LVzjxaIz0aMg612PxsrrfuUXvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)