UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I3sXttz42XNHqS75AIDrHaJpgi0q8QDY0sjxl/CmjuE='
WHERE
key_id = 'cfad14d551f226a76c87c93e295605c02548006ade20b9af0eddc8a45e0895ec'
AND (
token = 'I3sXttz42XNHqS75AIDrHaJpgi0q8QDY0sjxl/CmjuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)