UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PrO4TDgxIL/mV8zXo5tOT3/Ot4u5Lm0hDLl0dMDHREU='
WHERE
key_id = 'f27a0ce9ec58c06d2e8bbf190d918cedd301a9768227f04ef7d5ce8737d95dfb'
AND (
token = 'PrO4TDgxIL/mV8zXo5tOT3/Ot4u5Lm0hDLl0dMDHREU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)