UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdSLnVhTb8dDjWxA33bwefv0pC5kZNDieDILFdQQ61U='
WHERE
key_id = '9f5117bde49ab9c64c9d5777cd3d0d8c8616bb98aad29f92d0d1960429bac991'
AND (
token = 'zdSLnVhTb8dDjWxA33bwefv0pC5kZNDieDILFdQQ61U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)