UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ph+B83sjRRXXTYONlRlS2k4wEDDagqybsRhz/+OZtt8='
WHERE
key_id = 'cd1b97ea604dffd91a336e33eda5ee460dc03e66535a2fa642497a375fdfbe63'
AND (
token = 'ph+B83sjRRXXTYONlRlS2k4wEDDagqybsRhz/+OZtt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)