UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3dCt1VFNBwt8+w/JPs7k9V3sI9L5QMLYTmOpp93/qF8='
WHERE
key_id = '05c68e31d0ce449a4f18a25193ee194fb30209b995e486f8e643b502a5f3b693'
AND (
token = '3dCt1VFNBwt8+w/JPs7k9V3sI9L5QMLYTmOpp93/qF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)