UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQ4ipsUX2fkoX07dpo/QafGuKNPDxKvca2M9Vruh38I='
WHERE
key_id = '483d3b7a73618f48d336e0f9e4e093d054e83c115b807b06415c153eb2ddff12'
AND (
token = 'XQ4ipsUX2fkoX07dpo/QafGuKNPDxKvca2M9Vruh38I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)