UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gVYyTEJvE2GBd/FaK+5AyJ5rQnHLliWFxisS9Ruun0g='
WHERE
key_id = 'd6bee0f71d60ddde54ee1eeac422c68e23e97ab88e4acc938580e61c46017693'
AND (
token = 'gVYyTEJvE2GBd/FaK+5AyJ5rQnHLliWFxisS9Ruun0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)