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