UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7G7Bo78ewVv3J43PWJSLztPqDzVeTIL6/ze5Ou1Tznw='
WHERE
key_id = 'c03ecc0e92abf87197c425b52a3bed7c66f534c4bd73964dae6acb1e8367c198'
AND (
token = '7G7Bo78ewVv3J43PWJSLztPqDzVeTIL6/ze5Ou1Tznw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)