UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2vh1N7giiuCg0DajTf0NPY9hs8dll3CjUMdlHtVy7wU='
WHERE
key_id = 'a4ab97593678d3b5d0a840d6554e4fb9e59bc634186a5fe4fcf0cd54d8bbc452'
AND (
token = '2vh1N7giiuCg0DajTf0NPY9hs8dll3CjUMdlHtVy7wU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)