UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HL9VccNY/t9WgVzQiPHwCUsjYtkwVUpBfdKASzymNqI='
WHERE
key_id = '970a9a177115c2d58aa6fe4cf109448d9df0e7fa3f47d44215ba2dd50aec50b0'
AND (
token = 'HL9VccNY/t9WgVzQiPHwCUsjYtkwVUpBfdKASzymNqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)