UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3nKhCmTE9hrA+KBGLvJ12cCWa+5tjK1br9cUqB/cby0='
WHERE
key_id = '8cd17a5bf06bc625b108cc974bc10b4ffa9265a11939ea89434e3689cf94fa09'
AND (
token = '3nKhCmTE9hrA+KBGLvJ12cCWa+5tjK1br9cUqB/cby0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)