UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxt9YNOTy2YBh3Zdy8hbJ+wfEi+qSPrNZZTku66AFzw='
WHERE
key_id = '7cb66152093bb6365a1b631a92c7b2fdef81a2e5020a4e2662cb9d83f910c6b0'
AND (
token = 'zxt9YNOTy2YBh3Zdy8hbJ+wfEi+qSPrNZZTku66AFzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)