UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/fBdZ+dwKPw6Oj26KQiLEyVGGSmgUrYzvjb4KIl/1mk='
WHERE
key_id = 'cd4ae7a93463f3ea7eaaadf73bab36c8e3a2e1102e4567b399e95f79f3fb3346'
AND (
token = '/fBdZ+dwKPw6Oj26KQiLEyVGGSmgUrYzvjb4KIl/1mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)