UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PNXRsIe6agYONuVFHwNewF4k66hgZBnF8XHQGM/Apw='
WHERE
key_id = 'dfa8a726836bdfa0d04a4f9e76b2e28a4fc861a7f1aff9608b4885fd7cc6f074'
AND (
token = '1PNXRsIe6agYONuVFHwNewF4k66hgZBnF8XHQGM/Apw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)