UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'slga2yYifkvy1d1DlFAV6/D/nKyCpYfejfsCX+riPwY='
WHERE
key_id = '3ca66b6f72c8e7ac6137cfee26ad8a8ff1086f680b04c9ff2ae7e0e022be3297'
AND (
token = 'slga2yYifkvy1d1DlFAV6/D/nKyCpYfejfsCX+riPwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)