UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C86lh5s6Y1BmZuR/+spRWRZuLqoe+97Rzz5qeHh5WSA='
WHERE
key_id = 'c0234c4de4f1028a83238cd7b4d17fcf02f1c347bc057ff2b5f4137a03cae732'
AND (
token = 'C86lh5s6Y1BmZuR/+spRWRZuLqoe+97Rzz5qeHh5WSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)