UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WWW1aDhwe6KRpIFtGX0Pk2b0vLbQK5PxTUK6q8XOuj0='
WHERE
key_id = '0d4715bc32e104857425bd22a823e86d84310f7de4ca0083eeef992dd8a1bb9f'
AND (
token = 'WWW1aDhwe6KRpIFtGX0Pk2b0vLbQK5PxTUK6q8XOuj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)