UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lo1a+bSqx1suxO5sjFs3ztBORg4SzscHa1Rc5V40znQ='
WHERE
key_id = '6f817de130448e8a26631f3d9030b49d9ae594a79fc785bb41aaa52824982568'
AND (
token = 'lo1a+bSqx1suxO5sjFs3ztBORg4SzscHa1Rc5V40znQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)