UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0aNe6Y91loMP/GKeE1mPiyvx6BaCwMzRJ8NKK9qjDEc='
WHERE
key_id = '5c78a5a991ff76304dacabb355b7fb7f2420b717eb421947a4b7aa24727c47b9'
AND (
token = '0aNe6Y91loMP/GKeE1mPiyvx6BaCwMzRJ8NKK9qjDEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)