UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LwHVbWxBOSgBa2E6M9hrKj88myfrFZEVU50NQr9QBFg='
WHERE
key_id = 'be7c22a9d50fab53e0aa18c8c54231b9748bc76f2dd0e06111bf24446ec195e6'
AND (
token = 'LwHVbWxBOSgBa2E6M9hrKj88myfrFZEVU50NQr9QBFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)