UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XylK/ZNkKkqP41FqHGnCzjX4LJyNnm9++9S19S9VzGs='
WHERE
key_id = '7ac38982e1d8456334a6030f3610a857c8f535de447b83187188b2bb772e44b1'
AND (
token = 'XylK/ZNkKkqP41FqHGnCzjX4LJyNnm9++9S19S9VzGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)