UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/LNEi/59nKhZOzop8v3WmdJqews89eMnZK31xfjV4a0='
WHERE
key_id = '0ccfc328c983b446286e45726f2e3fc148e4743ddebc5cadd514afc9bec852da'
AND (
token = '/LNEi/59nKhZOzop8v3WmdJqews89eMnZK31xfjV4a0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)