UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HV3pZRKf9TuCdyEzLwHFAqQegIPtWSJKUPzk4wKscio='
WHERE
key_id = '9d7876d5435e596a3d615ee7faece998d9ab79cc6da57effe799a20ecf9b1a0b'
AND (
token = 'HV3pZRKf9TuCdyEzLwHFAqQegIPtWSJKUPzk4wKscio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)