UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9RJwMUJLjTOiHK3J/C1B32+dpDbePFdXYDGQFBoMa4='
WHERE
key_id = '6987a37b504ddbd96c0611eec7b608e11f8c4d00d9e5378be580fbff7a34eafe'
AND (
token = 'R9RJwMUJLjTOiHK3J/C1B32+dpDbePFdXYDGQFBoMa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)