UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mHJtg2rVPKiPxEcSYsVPToSHk4nhHD2MksthWGkKoPo='
WHERE
key_id = '4378e7de0f7df1774f6ad430b45f0ecc217197c6921055c809c07673ca690909'
AND (
token = 'mHJtg2rVPKiPxEcSYsVPToSHk4nhHD2MksthWGkKoPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)