UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OfEc3/1frjdX1va/Mj8thCyOBli0V/ibavipouRlNQY='
WHERE
key_id = '7fe55f927c1f796a5c19a2f9cb0768d7c718e31f772342d74ba3382169b7f5f9'
AND (
token = 'OfEc3/1frjdX1va/Mj8thCyOBli0V/ibavipouRlNQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)