UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lj1bfwI2tm1lCm4bHn/dfFB5wr5FzfuZXO01oN6umIA='
WHERE
key_id = '9e7a4aed8c82a30f65912f4a14a96d177985ae12537afce30eb055dd2fef1738'
AND (
token = 'Lj1bfwI2tm1lCm4bHn/dfFB5wr5FzfuZXO01oN6umIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)