UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FhsRxj+aaAjK1ND44IbCQTIBOv9a5/RHcDQXpYW4U6E='
WHERE
key_id = '7f227aca5c8047b25fbff9b3f9b4a3a507a08afb85ed3d2a2767af1a64be608a'
AND (
token = 'FhsRxj+aaAjK1ND44IbCQTIBOv9a5/RHcDQXpYW4U6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)