UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7/qWFGvPSVFTBoxi/90GIwgI61mtARC014cW6o4hIJM='
WHERE
key_id = '1c9e5348189c910a7052948efe738f758d98ef3fc1870b007672ea87f1d3d230'
AND (
token = '7/qWFGvPSVFTBoxi/90GIwgI61mtARC014cW6o4hIJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)