UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8euPD2AV8b5hYWzZTjTWjPQL4pqjeVoLizwFLfvy4wI='
WHERE
key_id = '593831d4e60e9393f62fcce27e76675c555740a0c6b2d2e4a6c35739d1bb5fdf'
AND (
token = '8euPD2AV8b5hYWzZTjTWjPQL4pqjeVoLizwFLfvy4wI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)