UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WI0WzWH6gDTC0dGa/3liy1KbLbbS4J1Krslzc4+3eME='
WHERE
key_id = 'f6ef6fe142aa508a97dc1d4ce2c9370120cd49c294ad0cd0392f28b05a65664f'
AND (
token = 'WI0WzWH6gDTC0dGa/3liy1KbLbbS4J1Krslzc4+3eME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)