UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'znEfz2tgwrurknGrc+pcosFij59p1LPu2wOQXqyK+ns='
WHERE
key_id = '8effa72b7e31632ffcf657135dddfdfd22ab40cc0d29d36a9030bba085c64281'
AND (
token = 'znEfz2tgwrurknGrc+pcosFij59p1LPu2wOQXqyK+ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)