UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QchlYFf5OySehmhY2xQbUEjmMyYfbTrwxwaGhz3Qopc='
WHERE
key_id = '2ca391a113a4178c0189c043aca6c7a307c5c81bc8f8417f9bbac8852f8f42f0'
AND (
token = 'QchlYFf5OySehmhY2xQbUEjmMyYfbTrwxwaGhz3Qopc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)