UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ee2NG1ZugWCkRej3zJ3wy5ysed5JaN3fivwkyUgNZw='
WHERE
key_id = '81b849545621fe1fe971280410ba08a15376241bb55491372a926f55a92aed37'
AND (
token = '+ee2NG1ZugWCkRej3zJ3wy5ysed5JaN3fivwkyUgNZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)