UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9jDig2noH5o6CAQWwJEe0KyYaw7yG5agCoHzAKPo6LU='
WHERE
key_id = 'a34fc509976624183752c5ffb4572365ffccd5be75cb02b1ffc60887254657c3'
AND (
token = '9jDig2noH5o6CAQWwJEe0KyYaw7yG5agCoHzAKPo6LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)